package com.shtel.customeraccount.mapper;

import com.shtel.customeraccount.entity.AcconutInfo;
import com.shtel.customeraccount.entity.ConsumerInfo;
import com.shtel.customeraccount.entity.RechargeInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
@Mapper
public interface QueryMapper {

    //查询充值缴费记录
    @Select("select * from rechargeinfo where creditnum=#{creditnum}")
    public List<RechargeInfo> queryrechargeinfo(@Param("creditnum") String creditnum);

    //查询消费记录
    @Select("select * from consumerinfo where creditnum = #{creditnum}")
    public List<ConsumerInfo> queryconsumerinfo(@Param("creditnum") String creditnum);

    //查询关联银行卡、翼支付账号
    @Select("select * from acconutinfo where creditnum = #{creditnum}")
    public AcconutInfo queryacconutinfo(@Param("creditnum") String creditnum);


}
